Go to the documentation of this file.
00001 using System;
00002 using System.Collections.Generic;
00003 using System.Linq;
00004 using System.Text;
00005 
00006 namespace FillCustomQueryTableCL
00007 {
00008     public class PreselectionFilterQuery : PreselectionListQuery
00009     {
00010         private static string QueryTypeName = "Preselection Filter";
00011         
00012         private static string GetParametersQuery =
00013             "SELECT " +
00014             "    0 FromMask, " +
00015             "    RelatedQuery.[Dynamic Mask Filter Name] [Name], " +
00016             "    [FPar].[order], " +
00017             "    min(RelatedQuery.[Query Name]) RelatedQuery, " +
00018             "    min(RelatedQuery.[FK Table ID]) RelatedTable, " +
00019             "    max(RelatedQuery.[Visible On Form]) [Visible On Form]" +
00020             "FROM [Dynamic Mask Filter Parameter] AS [FPar]  " +
00021             "    LEFT JOIN [Dynamic Mask Filter] [Query] on [Query].[PK Dynamic Mask Filter ID]=FPar.[FK Dynamic Mask Filter ID]    " +
00022             "    LEFT JOIN [Dynamic Mask Filter] RelatedQuery on RelatedQuery.[PK Dynamic Mask Filter ID]=FPar.[FK Parent Filter ID]   " +
00023             "WHERE [Query].[Query Name]='{0}' and [Query].[Use In Query]=1 " +
00024             "GROUP BY RelatedQuery.[Dynamic Mask Filter Name], [FPar].[order] " +
00025             "UNION  " +
00026             "SELECT  " +
00027             "    1 FromSys, sys.parameters.name [Name], sys.parameters.parameter_id,  " +
00028             "    sys.types.name TypeName, null, null  " +
00029             "FROM sys.parameters   " +
00030             "    LEFT JOIN sys.objects on sys.parameters.object_id=sys.objects.object_id   " +
00031             "    LEFT JOIN sys.types ON sys.parameters.user_type_id=sys.types.user_type_id   " +
00032             "WHERE sys.objects.name='{0}'  " +
00033             "ORDER BY FromMask, [FPar].[order] ";
00034 
00035 
00036 
00037 
00038         public PreselectionFilterQuery(string name) : base(name, QueryTypeName, GetParametersQuery) { }
00039 
00040         protected override void PreСorrectParameters(System.Data.SqlClient.SqlDataReader reader)
00041         {
00042 
00043         }
00044         protected override void СorrectParameters()
00045         {
00046             
00047         }
00048     }
00049 }